Asset/Report Value Import Excel Template

To begin working with the template, select the Download Standard Field Template, Download Repeating Field Group Template, or Download National Bridge Element Template link to download the desired spreadsheet.

Note: The asset/report values imports are only to be used when importing data for existing assets into existing fields. All assets and fields entered into the template must already exist in the system or an error will occur with the import.

Standard Field Template

All fields are not necessarily mandatory, but it is recommended that all fields be completed if possible. It is important that all information be entered accurately.

Fields of Note: Controls that use numbers (such as Deck Condition) Some of these fields have a limited number of choices available to them. If a control's dropdown allows numbers "1" through "9" to be selected, entering any value outside of that range (such as "10") will cause an error when importing the template.

-OR-

Repeating Field Group Template

All fields are not necessarily mandatory, but it is recommended that all fields be completed if possible. It is important that all information be entered accurately.

Note: Instance ID's for repeating field groups equal the number of instances for the specified group of fields for an asset. Underrecords are a repeating field group. Instance ID 1 equals the first underrecord, ID 2 is the second underrecord, and so forth.

For example:

Instance ID = 1 Underrecord A Instance ID = 2 Underrecord B Instance ID = 3 Underrecord C Instance ID = 26 Underrecord Z Instance ID = 28 Underrecord BB

-OR-

National Bridge Element Template

All fields are not necessarily mandatory, but it is recommended that all fields be completed if possible. It is important that all information be entered accurately.

Fields of Note: Parent Element This field determines to which element the new element belongs, if applicable. In order for the import to work, the parent element listed in the field must already exist in the system and must be entered correctly.

Note: For an asset with multiple elements that share the same protective system, a ">" character can be entered to specify the grandparent > parent relationship and designate exactly where the new grandchild element should be placed.

Example: An agency has an asset with both element 12 and element 212 using protective system 510. However, each of those protective systems now has a defect that must be added:

12 > 510 > 1110

212 > 510 > 1111

When importing new grandchild elements, entering "510" into the Parent Element column of the template will cause problems because both element 12 and element 212 contain that protective system. To solve this issue, the admin can enter "12 > 510" into the Parent Element column to specify exactly where to place the new grandchild element within that asset.

Controls that use numbers (such as Deck Condition) Some of these fields have a limited number of choices available to them. If a control's dropdown allows numbers "1" through "9" to be selected, entering any value outside of that range (such as "10") will cause an error when importing the template.
Importing grandchild elements To import grandchild elements, the Parent Asset column of the template must

follow a specific "Parent Element > Protective System" format to ensure that the defect is imported to the correct location. For example, the Parent Asset column could read "12 > 510" with the Element column reading "1110."

Importing Users

To import users, select the Users tab on the Bulk Import page. This feature is particularly useful during an agency's initial AssetWise Inspections setup because it allows the admin to avoid manually entering user information one by one on the Manage Users page.